Columns

Grants

Dependencies

Details

Triggers

Errors


COLUMN_NAME DATA_TYPE NULLABLE DATA_DEFAULT COLUMN_ID COMMENTS INSERTABLE UPDATABLE DELETABLE
SID NUMBER(38) No null 1 null NO NO NO
PARTIC_OBJ VARCHAR2(20) Yes null 2 null NO NO NO
PARTICIPANT_DISPLAY VARCHAR2(20) Yes null 3 null NO NO NO
OUTCOME VARCHAR2(4000) Yes null 4 null NO NO NO
OUTCOME_SUBCATEGORY VARCHAR2(4000) Yes null 5 null NO NO NO
OFFICE VARCHAR2(4000) Yes null 6 null NO NO NO
START_DATE DATE Yes null 7 null NO NO NO
END_DATE DATE Yes null 8 null NO NO NO
EMPLOYEE_TYPE VARCHAR2(4000) Yes null 9 null NO NO NO
ID VARCHAR2(100) Yes null 10 null NO NO NO
TITLE VARCHAR2(400) Yes null 11 null NO NO NO
CREATED_ON DATE Yes null 12 null NO NO NO
STATUS VARCHAR2(100) Yes null 13 null NO NO NO
INTERCOM_LEAD VARCHAR2(400) Yes null 14 null NO NO NO
OWNING_UNIT VARCHAR2(400) Yes null 15 null NO NO NO
CREATE_UNIT VARCHAR2(400) Yes null 16 null NO NO NO
RCV_UNIT VARCHAR2(400) Yes null 17 null NO NO NO
REFERRAL_TYPE VARCHAR2(100) No null 18 null NO NO NO
NEXT_DUE_DATE DATE Yes null 19 null NO NO NO
FINAL_DUE_DATE DATE Yes null 20 null NO NO NO
LAST_MODIFIED_DATE DATE Yes null 21 null NO NO NO
SOURCE VARCHAR2(4000) Yes null 22 null NO NO NO
PRIVILEGE GRANTEE GRANTABLE GRANTOR OBJECT_NAME
OWNER NAME TYPE REFERENCED_OWNER REFERENCED_NAME REFERENCED_TYPE



References


NAME VALUE
CREATED 17-MAY-23
LAST_DDL_TIME 05-FEB-25
OWNER QART
VIEW_NAME V_CUBE_PARTIC_OUTCOMES_INTERCOMS
TEXT_LENGTH 752
TEXT SELECT DISTINCT O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD AS INTERCOM_LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE FROM V_CUBE_INDIV_PARTIC_OUTCOMES O, V_CUBE_INTERCOM_ALL I GROUP BY (O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE)
TEXT_VC SELECT DISTINCT O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD AS INTERCOM_LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE FROM V_CUBE_INDIV_PARTIC_OUTCOMES O, V_CUBE_INTERCOM_ALL I GROUP BY (O.SID, O.PARTIC_OBJ, O.PARTICIPANT_DISPLAY, O.OUTCOME, O.OUTCOME_SUBCATEGORY, O.OFFICE, O.START_DATE, O.END_DATE, O.EMPLOYEE_TYPE, I.ID, I.TITLE, I.CREATED_ON, I.STATUS, I.LEAD, I.OWNING_UNIT, I.CREATE_UNIT, I.RCV_UNIT, I.REFERRAL_TYPE, I.NEXT_DUE_DATE, I.FINAL_DUE_DATE, I.LAST_MODIFIED_DATE, I.SOURCE)
TYPE_TEXT_LENGTH null
TYPE_TEXT null
OID_TEXT_LENGTH null
OID_TEXT null
VIEW_TYPE_OWNER null
VIEW_TYPE null
SUPERVIEW_NAME null
EDITIONING_VIEW N
READ_ONLY N
CONTAINER_DATA N
BEQUEATH DEFINER
ORIGIN_CON_ID 16
DEFAULT_COLLATION USING_NLS_COMP
CONTAINERS_DEFAULT NO
CONTAINER_MAP NO
EXTENDED_DATA_LINK NO
EXTENDED_DATA_LINK_MAP NO
HAS_SENSITIVE_COLUMN NO
ADMIT_NULL NO
PDB_LOCAL_ONLY NO
DUPLICATED N
SHARDED N
OWNER TRIGGER_NAME TRIGGER_TYPE TRIGGERING_EVENT STATUS OBJECT_ID




ATTRIBUTE Line:Position TEXT